package com.danco.training.zaneuskaya.connection.dao;


import java.sql.Connection;
import java.util.List;

import com.danco.training.zaneuskaya.domain.Book;

public interface BookDao extends GenericDao<Book, Integer> {

	public List<Book> readSomeMonthsUnsoldBooks(Connection connection,
			int months);

	public List<Book> readBooksSortedByAlphabet(Connection connection);

	public List<Book> readBooksSortedByPublicationDate(Connection connection);

	public List<Book> readBooksSortedByPrice(Connection connection);

	public List<Book> readBooksSortedByAvailability(Connection connection) ;

	public List<Book> readUnsoldBooksSortedByReceiptDate(Connection connection,
			int months);

	public List<Book> readUnsoldBooksSortedByPrice(Connection connection,
			int months);

	public List<Book> readAvailableBooks(Connection connection);

	public List<Book> readNotAvailableBooks(Connection connection);

	

}
